package com.eduction.service;

import java.sql.SQLException;
import java.util.List;

import com.eduction.bean.ItemListExpertBean;
import com.eduction.modules.system.entity.ExpertItemMap;

public interface ExpertItemMapService {

	/**
	 * 保存专家与指标的关系
	 */
	public void saveExpertItemMap(ExpertItemMap e);
	
	/**
	 * 根据学校id查询信息
	 * @throws SQLException 
	 */
	public List<ExpertItemMap> queryInfoBySchoolId(String schoolId,String type) throws SQLException;
	
	/**
	 * 根据专家id查询分项表
	 * @throws SQLException 
	 */
	public List<ItemListExpertBean> queryListByExpertId(String expertId,String type,String identity) throws SQLException;

/**
 * 根据专家ID删除专家分工
 * @param pId
 */
	void deleteBySchoolIdAndExpertId(String schoolId, String pId,String type) throws SQLException;

	List<ItemListExpertBean> groupBySchoolId(String expertId, String type) throws SQLException;
}
